SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 698643 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 698643 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017455,454090,968509,839944,956417,270705,885144,103202,585424,860947,484065,789181,982625,490146,260218,563466,974202,482550,867831,716993,481056,238,427831,8604,484760,42731,712264,905521,225712,715840,947099,72940,1010324,390547,799444,437039,598647,295685,951176,50955,824995,722979,569584,639971,777307,603841,198697,772812,1023135,604340,408373,1027397,528497,241699,993908,953380,333662,471251,456508,717321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 698643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 698643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]