SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455399 LIMIT 1 [ RunTime:0.001417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455399 [ RunTime:0.004676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637555,153587,454906,367663,36924,265270,127017,275605,316817,398690,1047637,1032905,1020735,900598,192513,508216,114678,839451,1029107,890558,269188,948136,851304,289150,643081,245464,551888,1032057,557048,110338,746901,1229,1023027,520734,259177,351555,820351,645922,210404,584554,829731,910902,490626,500627,226579,199863,797467,804648,517601,470477,660909,898323,247537,275567,449935,311541,1047562,1037878,296830,679876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003530s ]