SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041647 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041647 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364449,50955,1005189,41531,495400,929356,130190,242880,548391,464092,311834,581219,672220,923790,457005,496501,192833,1047079,678546,220997,884214,728830,904771,479107,322532,651733,411797,445603,207174,1028444,396905,916746,185793,498614,728471,45750,929980,204647,698729,597172,1024253,620839,488316,792564,193007,515892,908601,898044,173161,130484,127261,813206,964068,847118,252320,783325,263390,118442,307985,782939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]