SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454184 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454184 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804873,661291,658409,344142,538505,576278,131804,1019984,647657,549099,110311,599813,410586,801310,812484,12460,305566,1022490,939210,1032423,250290,8591,974835,236799,753088,1042131,364444,525068,262687,376245,935304,346006,808478,991713,373722,797855,959032,663223,672611,624228,1001811,1027617,790407,83609,33000,106089,139101,59426,704497,704991,88848,401768,360848,438845,706757,713210,989521,424592,49081,458266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]