SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001117 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001117 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141043,23566,16024,345823,307303,581929,983496,586873,592862,946299,86022,784080,733324,982465,299056,1035842,648865,641004,724808,281789,602669,516987,741914,739767,152890,232850,959399,728492,880336,706379,447873,853011,848495,175130,820983,549295,174460,886746,985294,961522,382488,976665,686489,810340,572087,1033476,677092,640455,760155,1019440,1018273,821749,489169,956522,633476,1045841,824829,697030,840818,139068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]