SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103934 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103934 [ RunTime:0.005213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971374,179224,141388,518509,936049,598394,82189,929156,637771,245278,391707,307780,789791,538314,543148,56338,318319,751011,770782,707666,172366,548988,967776,213452,747543,880727,434377,272063,608607,393280,812654,36891,487864,327454,599748,883831,342772,933345,266702,345629,587689,411864,755069,953370,171075,941137,33775,36331,625926,338811,623109,138699,442434,859990,38937,665498,308234,834603,72352,588781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]