SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195114 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195114 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137585,305420,743725,971120,636560,669242,871674,627065,362113,826401,852614,527284,190654,729566,1034604,738204,62109,700972,538122,451219,334213,385110,432603,812928,512288,353369,530210,788164,143015,552776,402119,210249,943993,922799,142049,557738,1032512,675604,654573,432935,302454,266258,782572,127633,47098,315180,519702,819997,19298,778322,728183,884144,413477,783952,568102,601918,482388,647900,145347,794594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001345s ]