SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454053 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454053 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574857,1010415,128100,613405,166967,506883,547500,466685,145916,88177,1001404,714947,943067,311783,618324,768382,401892,513225,745623,724343,537319,568157,635989,735418,427578,326779,138795,188157,848668,62964,867436,292868,898472,479927,166164,560680,862177,442496,1005519,573784,385471,788347,1025662,238022,82873,254296,898223,919794,1012747,58247,413231,840238,831704,695486,940560,93622,983968,581007,779771,805018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]