SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240904 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240904 [ RunTime:0.002686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022203,368124,30449,876920,663963,434132,163034,465969,371887,252403,718024,391915,603935,384420,625089,711823,371012,219620,502795,767549,663435,83707,34567,524462,900181,755843,373466,542821,861805,325703,795329,355711,243990,296540,632963,468437,748805,714700,671778,791669,297380,734512,405241,383255,180393,444828,42104,582151,433092,771790,655221,219316,159226,323637,682392,279317,656521,102719,495519,802870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]