SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450097 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450097 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037083,563889,430193,10113,961356,1002134,647113,348889,392052,164046,360899,312392,787878,190809,213951,609693,937975,858527,963047,755040,872448,48459,520851,1021762,22862,421122,795487,936885,219650,137077,233157,793557,814290,478825,142695,705256,297929,100121,62519,958151,818590,776773,935071,109307,565604,6610,414944,476688,230636,169388,263543,975989,590571,917543,685382,526012,154843,591869,608184,859905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]