SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512584 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512584 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241058,249262,184160,939535,728766,966672,140055,1021452,81229,204808,438374,643178,987205,880866,53813,641123,124825,541103,346982,905583,15766,407613,1027831,784269,1012272,968701,652056,715766,1013670,893765,738794,933914,798458,435181,620900,867784,548087,958009,211890,837957,667568,691945,598297,923214,41864,190434,195536,964070,737986,729227,586353,901322,340895,927221,698053,338945,927266,856199,243531,74339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]