SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 719969 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 719969 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901502,923212,161148,829971,1040779,985899,664809,57517,154260,213193,389641,306521,1045776,100511,780194,406470,952742,1038288,406368,568167,284411,455535,991858,199692,148610,30703,158905,440429,1048369,706277,490914,349720,802988,286978,690043,634478,8613,48919,677198,159681,449724,220505,1039660,351556,322038,1025495,226238,725162,285889,464763,424486,828669,347435,922766,382389,649736,456572,507055,283159,173691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 719969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 719969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]