SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 738512 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 738512 [ RunTime:0.002810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536472,305493,1029248,319580,332673,953832,48105,17137,134390,1029763,281117,695892,703103,34689,910907,728412,825392,479722,620440,936044,419722,896833,275215,994849,627965,455858,1044170,434051,769799,55226,1046194,652598,341670,382287,349588,295245,773268,974720,723477,66043,150964,626860,126158,953100,249552,1036265,226534,522062,710365,417223,474723,818362,1029016,63300,647947,351677,394955,141740,252734,922362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 738512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 738512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000883s ]