SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033686 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033686 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928536,403251,451686,429742,917171,422731,237594,208162,326016,947940,902736,974428,239706,807011,641896,617026,716652,725844,706515,229562,250599,193651,701317,203300,334438,470972,722992,269432,266506,149792,191408,415579,352887,145649,314425,1012848,688678,959855,742683,645996,1041725,516848,902079,144637,118335,945172,876257,718652,1042072,704547,31100,446149,42295,57357,927070,900342,688851,677215,770696,942312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]