SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42163 LIMIT 1 [ RunTime:0.001637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42163 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531157,118060,506066,844583,551093,621167,994686,323671,360204,983758,178167,632204,702800,474638,993839,429270,641627,919903,535504,612271,158505,718522,970137,748702,427894,855379,633043,895108,44494,588026,612290,762756,808358,800417,475594,61531,1028858,767685,868301,383925,918727,176149,433604,357511,663687,838561,395684,921414,202778,663647,193863,877215,152672,57654,375763,840990,587445,512047,177437,896798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]