SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016433 LIMIT 1 [ RunTime:0.001595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016433 [ RunTime:0.002731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271470,726624,61259,359263,209055,477210,162949,101513,552634,345627,233853,826744,151792,707819,519755,545615,877601,990012,266589,602092,13737,393344,240636,1023116,110013,199986,337531,647182,532488,736851,224548,257577,629479,569359,475891,580833,796593,978745,894577,957866,489369,826803,1040163,234870,379729,482741,535940,747072,865004,1007495,194702,440501,465629,622571,107757,339609,66179,706044,40252,905941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]