SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 921011 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 921011 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990768,901186,540248,1044838,809820,286894,882187,344349,326489,416172,736658,1044283,864784,651916,101248,235361,378839,86176,517917,1028699,49492,493442,856937,518277,105106,787593,722459,918789,21214,505116,860494,177654,951732,196875,266047,111622,667123,544917,887656,166674,583071,967800,949324,382004,945320,343518,873586,799250,262639,710872,294146,828085,760081,150246,340887,119826,661678,961554,45940,461373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 921011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 921011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]