SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284551 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284551 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961607,824029,120764,402376,780320,472949,431714,839419,385476,376277,541809,569496,1022587,160715,268854,1032723,560791,127113,57408,64910,334646,1012757,44201,703562,345295,11243,6543,468943,775765,832244,13305,535491,670640,214703,58021,534719,875577,270845,999304,974298,593344,255239,984061,107701,693363,598806,25751,134339,604214,1026928,207685,50559,892438,677545,1042073,822609,334751,101013,669926,469277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]