SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805090 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805090 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807717,785279,120713,684389,254729,1039090,631017,269523,431272,62490,639294,468455,733383,906093,28018,525804,594119,512079,923897,919394,593384,414048,550733,967019,152804,885813,426028,423569,630018,1019897,495601,239440,28551,833633,689565,953286,34163,313957,147000,167441,779299,496435,978339,709412,533834,634616,851395,2460,33798,1002297,994367,508167,109168,523186,231590,637205,745169,418367,194830,889154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]