SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505059 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505059 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603485,662355,95005,469912,41576,597333,515662,408696,708150,345859,292733,1048318,634629,590682,632318,737890,297722,347695,222591,803150,350429,277112,459358,428213,274737,432210,625361,235578,324006,160780,69275,42481,57358,180591,896275,117344,848206,870249,900726,165304,71244,1032257,233073,764598,306532,747211,317914,601872,789956,429924,832009,556826,270844,1033779,308672,623446,531528,155270,53183,246036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]