SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473955 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473955 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326543,502876,964721,960782,973996,212070,727269,220202,211995,701618,1009086,993361,787856,70322,1048889,148578,10843,151400,1027358,679970,240255,764640,335746,689259,551195,194951,40370,88413,920495,1002820,545384,663400,2022,27613,369081,269228,93369,960,511025,129928,492331,452007,951761,286087,12537,37451,1004478,721901,202728,142651,710714,653474,257041,352184,103597,109165,565361,282015,225313,604157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473955 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473955 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]