SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409810 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409810 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104112,140993,899099,862223,308454,997721,572958,895420,103135,643957,77972,986424,522471,384340,105166,1036563,659342,422989,943477,354451,61654,1030152,755611,564204,744537,759952,812966,733021,89273,133700,49110,311280,273412,131160,237844,592322,190855,499315,245853,89896,677329,295253,648630,665485,623149,701802,33561,47513,559957,457195,211317,938988,602286,528231,385140,1006195,754527,27182,147950,448945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]