SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453203 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453203 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318244,962747,184227,445203,204018,1030075,493274,262010,836902,715268,94116,930252,377988,800362,893246,812742,743213,232966,1048216,383713,415762,288099,3416,176189,851429,444964,946719,446001,1018692,204506,807007,116662,914111,847252,730540,827914,797919,192043,774919,872523,414045,390997,1047233,539310,94177,971628,979628,222416,690406,556761,938000,108677,527728,714339,412466,110407,81020,893865,701259,186337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]