SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181015 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181015 [ RunTime:0.004304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015519,143275,87233,419989,87866,701010,335275,615135,1047777,645689,874853,79497,381913,995828,751372,528083,831344,818966,1022668,41576,292876,924732,575442,177342,58596,140718,549842,399601,805171,244816,292456,658451,947923,952179,512783,168452,445320,383194,246050,439733,175663,540452,1033284,20332,779166,685820,188720,97396,242986,726509,621831,837954,917160,632340,864934,555086,852536,965280,287014,275909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]