SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511092 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511092 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571936,32835,682401,420511,297102,182116,176172,937860,797448,178945,28374,785703,295032,941492,1023846,564264,358868,992089,334528,920888,288442,634030,404683,432399,551160,558677,690542,597639,1012025,371409,891616,141831,502725,355171,891681,863966,17310,703328,13543,564516,656489,89406,187705,899298,491206,893978,1005693,668054,984147,162191,1007792,89556,335849,220720,122073,441758,1027081,829209,951622,122205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]