SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530320 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530320 [ RunTime:0.007758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523772,332456,187153,476580,979997,841428,938604,963316,515786,620449,947715,247388,515679,604443,715968,1043441,544058,117469,653307,746836,779097,58549,719767,68533,24521,720329,728306,278985,255734,933743,373889,554365,90353,744659,977336,129752,931505,1032864,1007966,808718,446682,458965,327695,694420,437428,412373,238004,804643,544823,597071,345349,126277,910791,838234,579851,644392,633517,279002,38330,751820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]