SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 662610 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 662610 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623415,342390,450817,402334,36595,691360,875068,891133,624592,231709,813101,273470,798908,52979,145101,831401,153905,55384,772392,392520,735733,166694,228200,180848,839548,815469,813279,966790,852544,834226,524009,1021057,717648,831090,857825,623977,300020,926110,787928,684099,130934,723747,235638,543033,330953,718561,779503,540,295938,869418,41043,369536,685136,129280,96720,316000,310459,650184,88845,339010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 662610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 662610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]