SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506410 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506410 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882753,250647,236096,630239,583158,995615,183163,37721,176553,620838,940021,670931,826006,47652,446661,600562,883397,445472,1000175,636479,803543,497021,343756,564314,598132,513662,929111,46695,517113,947982,902100,143233,492983,1000954,473026,751522,629333,188198,183218,976360,361578,818171,1046239,502370,771103,161757,89335,797793,289349,726355,420560,564160,695381,491030,392993,724310,672095,52826,863376,960993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]