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` = 493454 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493454 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289413,747288,612675,703398,513461,662524,267467,144976,315209,840869,609025,306577,400624,39139,964244,705327,60727,375912,306571,542168,162968,1010583,902515,546007,110122,1002213,201662,254228,737835,879810,336379,699278,632982,1021183,345990,112862,79592,485501,539933,332159,500487,273063,582214,199749,836598,394485,446482,139019,807176,134610,933498,855534,279830,117629,918590,442386,519633,365735,365358,627723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]