SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195105 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195105 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900930,163717,153849,671451,42278,505180,255178,344298,411761,760979,532328,494808,809269,637125,371868,679216,641358,416295,528609,661901,580526,433208,432630,69234,11246,82674,423246,657306,867483,74496,923804,258309,170040,437218,359276,615761,352397,221171,330879,706616,950632,544294,469735,527150,514758,1026570,288854,974811,979617,995507,360958,259253,442849,465948,135467,378052,406989,594793,67338,742284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]