SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024067 LIMIT 1 [ RunTime:0.002302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024067 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66522,993068,388912,425296,392687,378110,906378,789521,979130,538953,808933,873396,748899,843244,416778,243668,19857,622485,195199,1035377,206817,960508,585436,936030,131267,497705,428651,953698,738380,322216,523718,932904,607888,220204,54298,182834,565163,67383,687779,160623,397645,874061,598587,833523,352069,219768,773555,650870,171426,143281,665518,614303,214452,514348,542653,983434,422587,841485,475584,656982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001678s ]