SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545568 LIMIT 1 [ RunTime:0.000965s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545568 [ RunTime:0.001455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654754,491911,1023339,317310,923294,88446,44702,621622,529040,232802,178863,268755,872539,579132,659421,221528,515225,464336,440157,17710,258132,288453,948988,764462,258114,183187,573939,858817,411828,1044824,775573,1022911,191547,262510,443862,955045,367566,567373,821471,356383,428317,809672,759615,397051,803005,771963,684868,284802,67190,765310,527078,371375,405274,697550,569813,999312,312757,443244,414874,667048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]