SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296940 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296940 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041347,664520,201441,751220,380186,710972,754985,37508,1018559,688078,14410,758358,5832,351033,783465,544057,672651,849879,15197,528912,753160,948603,228543,422176,819610,806818,841858,524075,596812,950602,570176,148324,160944,732783,432406,269470,472510,830769,80532,863851,648658,751094,300693,961684,440228,310269,719908,774188,381994,723912,303337,673196,186256,860329,943758,339272,1029171,983899,565825,521143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]