SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530470 LIMIT 1 [ RunTime:0.000628s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530470 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632670,367003,881095,233140,739386,618963,843487,808892,348637,890762,518920,754496,625093,109611,130466,191574,125356,372423,274678,293014,132239,910494,548371,274844,963952,131825,271618,66680,120274,543712,172951,844724,454299,516738,644181,989686,969374,259692,440306,1027551,407772,644003,617424,987687,859383,277725,24407,269970,138070,656599,702407,606189,205789,183932,546587,470905,203859,118265,442888,591100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]