SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540063 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540063 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353527,673566,550950,409023,97221,52792,322432,3695,972366,192978,585914,169058,282180,968173,216416,266523,995381,639678,407804,321204,905147,774868,178463,222540,639063,222761,262962,539756,898559,843663,127104,396271,353687,735568,146107,744017,750899,40664,287097,511897,560771,158877,1004980,696665,737550,307913,495091,480693,114986,973899,676049,914625,597497,273789,400873,665999,270053,136793,511675,34978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]