SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528801 LIMIT 1 [ RunTime:0.000934s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528801 [ RunTime:0.002819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59691,590423,338126,391093,406602,499480,765976,159997,1043432,960659,351437,274614,1028349,274637,828470,619319,696886,525827,395656,962651,866474,128,400508,304162,379405,741171,226883,678910,32768,774520,890527,976712,130432,531944,728496,944780,858422,281927,673189,781052,115987,634017,889845,747982,454249,272583,70780,724792,146595,838666,559003,356831,357101,513460,709866,129390,95804,776772,627517,854444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]