SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684328 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684328 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033239,693643,995268,885715,168340,949515,483234,800685,721083,1044721,958442,1034483,364370,931721,887164,280276,549773,362253,371843,77375,560844,335470,336773,500173,421457,439362,1023592,378820,292359,769200,1020942,834107,621884,736903,838338,793509,299655,908983,940671,175035,459922,21991,271602,523231,909897,366002,12371,920345,48487,845557,304038,188988,1016597,782445,698349,759118,24469,328730,490243,285390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]