SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586326 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586326 [ RunTime:0.003052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25607,97483,948623,943578,450110,840185,578662,476765,565398,47024,807957,953009,213884,182925,499232,621996,49685,327544,516577,351550,663947,120976,700629,503415,155381,724042,709719,623272,921918,240043,970154,66833,187498,112955,288398,142799,791062,917872,455061,11056,559455,308628,1031901,1558,523880,645821,201145,377055,233093,96086,579167,373370,448167,657441,757356,959391,599343,927876,404771,101586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]