SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192654 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192654 [ RunTime:0.003316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946714,88393,874415,300012,939763,796920,582395,485957,19997,952170,25746,308218,441536,789668,102710,725209,171874,62424,401567,246316,357126,917140,158768,980198,540095,838704,971996,351752,679989,989079,355121,344049,845518,901956,249881,300037,275547,199051,89659,132317,762568,390490,713790,750397,679795,432655,935981,137981,980933,390589,559369,950324,1038957,619920,33566,569183,158328,101580,1031567,761259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001529s ]