SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508899 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508899 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502515,694533,270394,40050,574355,853479,578754,570171,302366,269364,866307,960376,984296,320294,494437,37316,2013,691930,409600,290832,799753,97363,312260,905807,600858,792042,250408,373212,969736,723170,436430,768132,990465,188451,629093,1008085,752593,820004,680820,163552,250460,54045,1048395,123662,619691,669653,96685,428783,333523,518595,924557,659184,967287,212095,415677,333347,290821,896397,219181,483632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]