SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038839 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038839 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185815,372903,506249,627720,988375,754839,270396,592247,246564,308149,1037800,575472,920007,752069,64729,558832,599846,485030,775758,407183,882716,328618,133256,498202,597600,999917,555157,440473,715861,275104,1000042,402946,466648,858101,1008006,1041441,1005417,112922,1043703,297431,201101,1045012,850791,832056,914295,1008074,442107,468119,80921,1018460,616358,547088,210030,99916,296737,44199,727578,890541,326643,153682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]