SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 915651 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 915651 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435846,343452,625296,501641,688057,58158,144640,404034,116068,427497,139589,55635,845341,363528,62295,150229,703542,883610,252212,54286,452650,198654,1043702,481282,43816,452249,301641,591176,539831,314221,461050,330091,453014,287843,596716,1018930,959054,789547,454137,927218,795271,590703,480189,128322,298522,946561,221159,726227,959393,437597,613286,472886,699722,642210,231621,780202,343102,553536,250763,121331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 915651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 915651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000793s ]