SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344902 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344902 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581251,161565,34354,1007113,406319,893123,729867,215132,1048377,932713,440942,654759,599287,524267,457039,999371,950544,314400,1000351,224458,520568,747004,1039866,605009,551403,106401,109076,194953,1021151,849006,943104,250474,323077,811728,973577,787086,219603,394057,431868,536293,529173,563159,660869,835121,234334,45122,754956,152130,429504,840741,132150,652618,326650,400414,32612,491965,412893,561341,129031,374092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003016s ]