SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551978 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551978 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448893,854286,310691,535799,608093,488408,819318,856600,303528,632075,591271,678465,618423,30751,302000,252045,755733,643279,278925,1007665,362692,146285,830257,82352,889352,389505,937792,534749,293432,340674,230918,941270,283418,628231,944424,32495,555879,953995,718369,335100,340864,468963,774671,850561,376694,268672,684247,599820,142084,393565,951100,8301,773235,795239,909356,68356,703143,365463,1029482,662505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002248s ]