SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449812 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449812 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378068,847592,878214,340540,1029909,538688,679951,410091,728777,264508,930079,442747,17670,542787,368811,216263,97242,1033054,425398,632279,313745,305666,433714,134760,898998,732988,86184,689789,103379,703325,91877,201771,649995,914881,574146,64102,686715,612517,911088,442359,835764,1025438,422011,798419,673673,114938,732379,74450,447910,121038,632059,223840,778363,443048,991412,733037,343685,859471,1029453,893711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]