SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043339 LIMIT 1 [ RunTime:0.003773s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043339 [ RunTime:0.007353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319863,284706,971636,248944,519475,958526,538119,592795,388522,822300,90174,179745,643899,693288,763166,525864,744356,164577,680016,145992,324639,606092,710521,543088,166350,515679,166558,913451,917489,1029187,215178,674397,806301,72106,857166,341677,478049,587837,525799,383291,508616,460942,771892,764350,551955,970039,237955,810572,808413,183281,189189,467300,516836,159206,467560,32607,25325,4571,355399,19724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043339 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043339 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]