SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019203 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019203 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536844,135420,246297,479216,528006,134917,310002,337098,874938,88656,870963,994026,687983,849525,225160,291466,614446,275681,918165,501042,933826,602824,996892,877055,907131,151821,504033,941966,409800,435310,27870,1018352,7309,623356,1029916,276651,240503,199650,694600,850089,658342,1035884,456458,168084,739692,211295,747196,171292,479567,802888,32034,656542,728998,1048010,658256,1048489,400275,465723,735443,24435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]