SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001858s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030210 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030210 [ RunTime:0.002977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204923,418266,327360,1031982,828948,106704,493821,307080,291741,113429,55291,84216,203049,1000408,607420,919821,386972,624146,240991,677158,353977,252941,485705,650090,522730,200669,436138,452572,678734,191387,746319,521872,388805,755845,246233,256180,31233,368769,643863,855457,211214,953454,307111,225613,666064,504213,506289,829968,264537,1039788,299381,1011736,797102,295786,509801,974218,652393,564524,896157,991744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]