SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450104 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450104 [ RunTime:0.003957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83144,585506,890546,688496,170262,751073,520795,474267,207765,782705,23333,964452,240109,105864,1046565,934393,548850,102680,705110,417395,98185,840285,668336,48578,794376,808969,504575,642518,153256,522211,357306,987822,951375,881064,76282,383885,1047933,774870,553891,559471,510527,141796,13954,247665,911310,1018084,113478,183237,164581,777964,482137,314761,480817,669902,903663,977436,523001,151008,303280,331363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]