SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046114 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046114 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789374,476058,144676,887438,117175,559909,670961,648558,378395,398717,722517,251181,642956,206355,335301,609765,424554,234133,410469,181426,863350,885423,661763,613183,263861,632377,1044670,91887,469117,956632,341961,503047,1004632,734908,808809,936833,44500,658105,217381,175668,426560,420399,722214,608521,280540,605412,679137,663158,74382,283094,396372,115483,293795,693544,429898,518140,932738,433565,346690,645637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]