SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427569 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427569 [ RunTime:0.006101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539383,431683,289924,1024248,753620,116375,74830,595516,880937,1034721,801458,372927,844416,742684,552033,826515,984984,260159,377671,834205,317816,1030378,601929,1036365,231657,989593,865671,654149,546407,502548,783743,365436,757970,528883,330751,938165,843846,29640,522077,27870,763163,812459,952378,676584,988546,282227,210927,166200,294003,581825,192083,759344,382211,641064,150500,852625,175241,329441,964432,307689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]