SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042428 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042428 [ RunTime:0.002507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251621,785725,869971,136027,258936,66873,322130,392572,597316,330429,1001993,795870,1044709,332824,10800,674437,8773,1047472,308276,334299,777434,444168,668901,318699,820773,702235,31102,307600,1045431,531907,37120,815467,768293,513,1011627,170417,222697,176784,479483,843886,182935,470937,695421,751513,484339,79885,573635,845625,446794,358857,47499,125622,153784,309472,872257,926385,992891,299435,590068,29783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]