SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045431 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045431 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46411,654816,625640,888182,823907,250711,266814,120547,674150,86919,759575,876742,543203,942055,199603,554013,805155,625834,1036734,660986,469335,45952,1024857,500510,850756,268290,840945,669045,283798,221927,180931,417970,459163,897468,717196,1043085,315252,656709,505535,419203,924692,796276,761538,442233,831391,882090,598790,969034,86728,648476,93641,1016992,747227,123117,971847,603477,734235,571165,429872,1002575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000905s ]