SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409830 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409830 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246274,685271,295902,700126,24085,55775,389439,398749,101678,335265,609490,69901,1029466,383016,531888,823814,966560,440556,400016,404902,982333,391636,584758,495572,766255,566694,286727,561146,433275,436011,268857,1018125,607960,613850,344875,498451,294563,218932,932503,49459,741364,2754,310069,55528,302414,852048,895847,905143,492934,560609,390900,941614,527072,846124,820341,387615,397569,377240,529921,121576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]