SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204205 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204205 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57093,301641,355338,1006485,151775,548218,197378,441981,389927,478553,55434,487474,179028,535695,821432,198260,294784,92606,19571,960839,329038,225785,521651,788218,323072,634609,328484,790342,19135,298970,76690,630833,885793,229190,887681,10335,506522,772687,726606,671872,75076,392838,1041991,4294,728493,1046840,1032648,163957,514694,989921,506051,985122,755190,889289,418625,129623,675162,200162,949029,343470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]