SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022226 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022226 [ RunTime:0.003003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610621,182895,20848,549761,910924,140350,353738,148668,739927,543053,665408,988665,149022,191395,807383,960441,839610,961087,901976,61281,213671,967019,438478,648281,471716,447823,136073,226071,201599,71207,619530,774605,910516,576232,424589,114871,345802,531512,442357,937841,871205,323960,339268,448254,938751,231370,582,796211,606379,621424,264819,21015,742511,281484,253993,506412,357389,536137,362065,41600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]