SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401865 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401865 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379487,429108,986803,108898,452745,179959,862955,624147,224581,712912,981802,259104,849345,529423,908405,1007727,195257,567636,818913,920726,698546,637101,18885,425644,113915,189338,950217,276494,136238,368240,600782,845224,500747,421286,627992,792448,467772,291498,264756,859997,477896,782651,700013,789124,316516,869151,40701,111465,708027,537522,946505,725554,166231,946667,312579,353342,142825,621549,394128,538102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]