SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149818 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149818 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412178,210578,762972,830414,697033,16591,624828,941067,110169,476246,68039,552954,580535,11348,13439,212842,378550,370129,812217,788265,539860,247337,328822,293018,110647,659343,842909,753551,238849,957638,529193,968377,941233,194334,1032425,572732,754423,125614,640570,515559,857315,1016739,634147,608559,249774,548567,270033,594198,248639,708419,480802,67823,200415,995309,594328,111107,351246,59868,1003118,464962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]