SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545902 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545902 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61593,118110,973216,987516,540286,44912,1030219,438150,587429,834323,453925,64458,931722,887598,158419,341109,99206,537075,356781,962799,418695,16703,813851,238815,1003227,256162,314499,2429,145073,429293,312394,720219,423935,6380,732836,1016194,976493,838852,5464,798998,673559,284048,591809,780766,229164,8861,706429,558159,69654,673357,329751,947214,687839,576434,820824,787296,946276,584492,704995,729490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]