SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528408 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528408 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72620,114897,143913,737265,36575,703291,254954,720362,913504,828682,290274,891507,740541,301043,334337,429843,159106,400643,74007,1048543,289098,944311,492166,145194,15079,696494,176872,1041116,67410,673230,898435,406961,477881,44023,729676,643524,520239,751458,309624,383391,964939,777760,492605,471232,571819,585862,175673,752872,642416,879128,643333,634692,691198,575776,606088,526266,32758,1031366,879048,278763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001497s ]