SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420090 LIMIT 1 [ RunTime:0.000719s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420090 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366698,625067,634052,626917,977233,114692,543154,484541,300385,305582,922390,770159,883818,540567,8634,796802,803871,364119,487039,1022454,947804,674205,108733,567136,849785,746050,932771,482112,297908,151931,643843,337907,612375,519501,644155,499768,739821,801489,1030649,1016489,778220,403805,158791,136646,594913,111436,784041,972445,694767,761117,106897,312596,1039410,463212,703128,899938,666209,764315,479147,189629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]