SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529841 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529841 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012456,412282,266905,840770,594983,564563,529540,561529,502818,28389,502903,355235,506648,306201,612743,1014543,494347,783129,581092,960747,848698,240135,642621,443541,394095,820614,899372,699369,1022627,294664,807576,794364,678657,227881,940176,983976,169327,1031255,910141,158065,173430,309138,279756,481367,177774,827215,211469,582489,840364,991250,583861,929863,852402,118947,313698,1001487,734244,400879,872113,240490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]